using System;
using System.Collections.Generic; 
using System.Linq;  
using System.Text;  
using System.Data.Linq.Mapping;
using System.Data.Linq;
namespace MRSite.Entity  
{
    /// <summary>
    /// 提现表
    /// </summary>
     [Table(Name = "withdrawal")]
    public class Withdrawal : Entity
	{ 
		/// <summary>
		///
		/// </summary>
		[Column(Name = "id", IsPrimaryKey = true, CanBeNull = false, IsVersion = true)]
		public override int id{ get; set; }


        /// <summary>
        /// 订单号
        /// </summary>
        [Column(Name = "orderno")]
        public String orderno { get; set; }

		/// <summary>
		///
		/// </summary>
        [Column(Name = "user_id")]
        public int user_id { get; set; } 

         
        /// <summary>
		/// 提现帐户类型
		/// </summary>
        [Column(Name = "gathering")]
        public String gathering { get; set; }

        /// <summary>
        /// 微信/支付宝帐号
        /// </summary>
        [Column(Name = "wxaccount")]
        public String wxaccount { get; set; }

        /// <summary>
        /// 真实姓名
        /// </summary>
        [Column(Name = "realname")]
        public String realname { get; set; } 

		/// <summary>
		/// 银行名
		/// </summary>
		[Column(Name = "bankname")]
		public String bankname{ get; set; } 

		/// <summary>
		/// 银行帐号
		/// </summary>
		[Column(Name = "bankaccount")]
		public String bankaccount{ get; set; } 

		/// <summary>
		/// 开户名
		/// </summary>
		[Column(Name = "account")]
		public String account{ get; set; } 

		/// <summary>
		/// 银行支行
		/// </summary>
		[Column(Name = "zhihang")]
		public String zhihang{ get; set; } 

		/// <summary>
		///提现金额
		/// </summary>
		[Column(Name = "txamount")]
		public Decimal txamount{ get; set; } 

		/// <summary>
		///实发金额
		/// </summary>
		[Column(Name = "sfamount")]
		public Decimal sfamount{ get; set; } 

		/// <summary>
		///手续费
		/// </summary>
		[Column(Name = "handlingfee")]
		public Decimal handlingfee{ get; set; } 

		/// <summary>
		///费率
		/// </summary>
		[Column(Name = "rates")]
		public double rates{ get; set; } 

         /// <summary>
        /// 重消费  
		/// </summary>
        [Column(Name = "cxf_fee")]
        public Decimal cxf_fee { get; set; } 

		/// <summary>
        ///重消费 费率
		/// </summary>
        [Column(Name = "cxf_rates")]
        public double cxf_rates { get; set; } 

         

		/// <summary>
		///
		/// </summary>
		[Column(Name = "addtime",IsDbGenerated=true)]
		public DateTime addtime{ get; set; } 

		/// <summary>
		///0待处理,1已处理,2已拒提
		/// </summary>
		[Column(Name = "status")]
		public int status{ get; set; } 

		/// <summary>
		///处理时间
		/// </summary>
		[Column(Name = "checktime")]
		public DateTime? checktime{ get; set; } 

		/// <summary>
		///
		/// </summary>
		[Column(Name = "remark")]
		public String remark{ get; set; }

        /// <summary>
		/// openid
		/// </summary>
        [Column(Name = "openid")]
        public String openid { get; set; }

        /// <summary>
        /// 微信打款交易号
        /// </summary>
        [Column(Name = "out_trade_no")]
        public String out_trade_no { get; set; }

        /// <summary>
        /// sn
        /// </summary>
        [Column(Name = "sn")]
        public String sn { get; set; }
         

        private EntityRef<Customer> _member;

        /// <summary>
        /// 
        /// </summary>
        [Association(Storage = "_member", ThisKey = "user_id", OtherKey = "id")]
        public Customer CustomerItem
        {
            get { return this._member.Entity; }
            set { this._member.Entity = value; }
        }
	 } 
}    

